How to enable Innodb as default storage engine ? Solution : Just edit your /etc/my.cnf file and look for this line: skip-innodb If such an entry exists, remove or comment out the entry #skip-innodb Next make the storage_engine variable to Innodb by adding following under [mysqld] section. default-storage_engine = InnoDB save the file, and restart mysql: Restart mysql service

This error message can be caused by an improper shut down, the apache processes are still hanging around and apachectl restart won’t work. Solution just kill off the hanging processes: # fuser 80/tcp 80/tcp: 3010 3702 4088 16754 # kill -n 9 3010 # kill -n 9 3702 # kill -n 9 4088 # kill -n 9 16754 # apachectl start or if there’s loads [...]

Moving domains from client to client in Plesk is pretty quick from the command line. Just replace DOMAIN with the domain name you want to move and CLIENTLOGIN with the client’s username: /usr/local/psa/bin/domain.sh --update DOMAIN -clogin CLIENTLOGIN

The AWStats package in RHEL4/Centos4 and Plesk 8.1 uses an alias directory for the icons called /awstats-icon, but when the AWStats contents is generated, the icon directory is different (/icon). To fix this issue, change this file: /usr/share/awstats/awstats_buildstaticpages.pl my $DirIcons='/awstats-icon';

If you get this error, you’ve most likely done a file-based MySQL backup restore, and the InnoDB files are hosed. The horde_sessionhandler table isn’t a MyISAM table at all - it’s actually an InnoDB table. The easiest way to fix the issue is to stop MySQL and trash the .frm: # /etc/init.d/mysqld stop # rm /var/lib/mysql/horde/horde_sessionhandler.frm Now start [...]

If you find yourself in the situation where you need to bulk add SPF records to every domain in Plesk, you can use this huge one-liner: mysql -u admin -p`cat /etc/psa/.psa.shadow` psa -e “select dns_zone_id,displayHost from dns_recs GROUP BY dns_zone_id ORDER BY dns_zone_id ASC;” | awk ‘{print “INSERT INTO dns_recs (type,host,val,time_stamp,dns_zone_id,displayHost,displayVal) VALUES (’\”TXT’\”,’\””$2″‘\”,’\”v=spf1 a mx ~all’\”,NOW(),”$1″,’\””$2″‘\”,’\”v=spf1 [...]

If you find that Horde (with Plesk) keeps refreshing when you attempt to log in, and there are no errors logged on the screen or in Apache’s logs, check the session.auto_start variable in /etc/php.ini. If session.auto_start is set to 1, set it to 0 and Horde will miraculously start working again.

If you have an open_basedir restriction that is causing issues with a domain, you can remove the restriction easily. First, put the following text in /home/httpd/vhosts/[domain]/conf/vhost.conf: <Directory /home/httpd/vhosts/[domain]/httpdocs> php_admin_value open_basedir none </Directory> If there was already a vhost.conf in the directory, then just reload Apache. Otherwise, run the magic wand: /usr/local/psa/admin/bin/websrvmng -av Then reload Apache: /etc/init.d/httpd reload

If this situation pops up in Plesk, it means that a user has changed their MySQL password outside of Plesk. The password in Plesk’s own database does not match, so the auto-creation of the phpMyAdmin settings fails. You’ll end up seeing this after clicking “DB WebAdmin”: MySQL said: Non-static method PMA_Config::isHttps() should not [...]

If you’re working in Plesk and you receive this error: mchk: Unable to initialize quota settings for someuser@somedomain.com Run this command to fix the issue, but be patient: find /var/qmail/mailnames -type d -name '.*' ! -name '.spamassassin' -ls -exec touch '{}'/maildirfolder \; -exec chown popuser:popuser '{}'/maildirfolder \;